!!!!!µ¥ÀÌÅÍ,À̹ÌÁö ²À ¹é¾÷ Çسõ°í »èÁ¦ ¹Ù¶÷(export)!!!!!

**sts/sts·Î ¿¬°á**

1.Á¶È¸ÇÒ¶§

SELECT *
FROM stsimg.PIC200 A
WHERE PLCD LIKE '2623010300%'

SELECT * FROM stsimg.PIC100
WHERE JOSA_NO IN
(
SELECT JOSA_NO
FROM MROKG510 A
WHERE PLCD LIKE '2623010300%'
) 

SELECT *
FROM MROKG510 A
WHERE PLCD LIKE '2623010300%'


2.»èÁ¦ÇÒ¶§
DELETE FROM stsimg.PIC200 A
WHERE PLCD LIKE '2623010300%'

DELETE FROM stsimg.PIC100
WHERE JOSA_NO IN
(
SELECT JOSA_NO
FROM MROKG510 A
WHERE PLCD LIKE '2623010300%'
) 

DELETE FROM MROKG510 A
WHERE PLCD LIKE '2623010300%'



3.»èÁ¦ ÈÄ È®ÀÎ

COMMIT